<?php
include_once('connection/connection.php');
$frmId=$_REQUEST['id'];
$distId=$_REQUEST['distId'];
$blkId=$_REQUEST['blkId'];
$panId=$_REQUEST['panId'];
$villId=$_REQUEST['villId'];
$cvcId=$_REQUEST['cvcId'];
$qryId="select id from tbl_dtls_q3_loc where village_id='$villId'";
$recId=mysql_query($qryId);
$rowId=mysql_fetch_array($recId);
$qrySrc="select * from tbl_dtls_q3_water_source_detail where loc_id='$rowId[id]'";
$recSrc=mysql_query($qrySrc);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/ajaxFunction_sp_detail.js"></script>
<script type="text/javascript" src="js/ajaxFunction_q1_new.js"></script>
<script language="javascript" src="js/cal2.js">
/*
Xin's Popup calendar script-  Xin Yang (http://www.yxscripts.com/)
Script featured on/available at http://www.dynamicdrive.com/
This notice must stay intact for use
*/
</script>
<script language="javascript" src="js/cal_conf2.js"></script>


<style type="text/css">
<!-- end face file -->

<!--
.heading_bgclr{
background-color:#CCCCCC;
}
.section_heading
{
	border:#666666 1px solid;
	width:780px;
	height:22px;
	color:#FFFFFF;
	font-size:12px;
	font-weight:600;
	font-family:arial;

}
.section_format
{
	background:#FFFFFF;
	width:1000px;
}
.section_format table
{
	border-collapse:collapse;
	border-color:#666666;
	background-color:#EEEEEE;
	width:1000px;
}
.section_format
{
	font-size:8.5pt;
	font-family:Verdana, Arial, Helvetica, sans-serif;
	color:#000000;
}
.section_format td
{
	height:25px;
}
-->
</style>
</head>

<body>
  <div id="section4" class="section_format" align="center">
<table width="1144" border="1" align="center">
  <tr>
    <td height="48" colspan="21" align="center" bgcolor="#CCCCCC"><b>Source Details from Field Survey </b></td>
  </tr>
  <tr bgcolor="#DADADA">
    <td width="44">SI No.</td> 
	<td width="44">Source Type</td>  
    <td width="61">Habitation Name</td>
    <td width="57">Type of Habitation</td>
    <td width="47">Location</td>
    <td width="45">Latitude</td>
    <td width="55">Longitude</td>
    <td width="61">Functional Status</td>
    <td width="70">Operational Status</td>
    <td width="44">Quality Status</td>
	<td width="64">Villages Perception of Water Quality</td>
    <td width="27">Yield</td>
    <td width="65">Seasonal Fluctuation in Yield</td>
    <td width="65">Water Table Fluctuation (m) Min</td>
    <td width="65">Water Table Fluctuation (m) Max</td>
	<td width="52">Average Depth</td>
	<td width="17">pH</td>
	<td width="24">TDS</td>
	<td width="19"> CL </td>
	<td width="17">F</td>
	<td width="121">No3</td>
    </tr>
  <tbody id="handpump_content">
  <?php
  $i=1;
  while($fetch_row = mysql_fetch_assoc($recSrc)){
  ?>
    <tr id="hp_row_<?php echo $fetch_row['id']; ?>" class="hp_row">
	<td><?php  echo $i++; ?></td>
	<td><?php  echo $fetch_row['source_type']; ?></td>
    <td><?php  echo $fetch_row['habitation_name']; ?></td>
    <td><?php  echo $fetch_row['type_habit']; ?></td>
    <td><?php  echo $fetch_row['location']; ?></td>
    <td><?php  echo $fetch_row['latitude']; ?></td>
    <td><?php  echo $fetch_row['longitude']; ?></td>
    <td><?php  echo $fetch_row['functional_status']; ?></td>
    <td><?php  echo $fetch_row['operational_status']; ?></td>
    <td><?php  echo $fetch_row['quality_status']; ?></td>
	<td><?php  echo $fetch_row['village_quality_status']; ?></td>
    <td><?php  echo $fetch_row['yield']; ?></td>
    <td><?php  echo $fetch_row['seasonal_fluctuation']; ?></td>
    <td><?php  echo $fetch_row['water_fluctuation_min']; ?></td>
	<td><?php  echo $fetch_row['water_fluctuation_max']; ?></td>
	<td><?php  echo $fetch_row['avg_depth']; ?></td>
    <td ><?php  echo $fetch_row['para_ph']; ?></td>
    <td ><?php  echo $fetch_row['para_tds']; ?></td>
    <td ><?php  echo $fetch_row['para_cl']; ?></td>
    <td ><?php  echo $fetch_row['para_f']; ?></td>
    <td ><?php  echo $fetch_row['para_no3']; ?></td>
    
    </tr>
  <?php
  }
  ?>
  </tbody>
</table>
</div>

<br /><br />



</body>
</html>
